SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Manchester NH Homes page 40
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:RARE opportunity! Here is your chance to own a piece of history! Situated on a spacious DOUBLE .57 acre CORNER lot in the heart of North End Manchester just minutes to restaurants, shops, parks, trails, and major highways. Step onto the formal entryway where you'll find yourself surrounded with gorgeous columns, exquisite architectural detail, and a breathtaking view overlooking your spacious front and side yard. The side yard boasts a fully fenced in tree-lined sanctuary complete with intricate stone hardscaping, a SALT WATER in-ground POOL (with a HEATER and NEWER liner), a patio with direct access to the lower level walk-out, as well as an OVERSIZED 2 car garage with ample storage and a second level. (Heat source in garage but hasn't been used). Stepping inside the home you are greeted by the spacious and sun-filled foyer complete with soaring ceilings, stunning archways, stained glass windows, and custom moldings. Here you have direct access to the two front formal living rooms and formal dining room with TWO fireplaces and exquisitely detailed original built-ins. The formal dining room leads directly to the kitchen as well a spacious screened-in porch overlooking the yard/pool. Here you'll also find an unfinished area perfect for a future kitchen expansion. Also included on the main level is a den with a gas burning fireplace. Heading upstairs you have FIVE bedrooms, three bathrooms, an office, as well as access to third level once used as dorms. NEW heating system 2022.
Description:RARE OPPORTUNITY ON THE BANKS OF THE MERRIMACK! YOUR WATERFRONT DREAM NEAR THE CITY HAS ARRIVED! Lovingly cared for and curated over forty years this charming home blends classic vintage details with modern updates. Nestled on a grassy double lot bordered by colorful and manicured perennial gardens you will feel miles away from it all in this most convenient location. As you enter, warm neutral tones and crisp white millwork set the stage. Light-infused spaces and windows framing sparkling water views will captivate you at every turn. Select a favorite book from built-in shelves in the living room and snuggle up to the pellet stove. A gas see-through fireplace creates a lovely ambiance shared with a showstopping dining room ideal for memorable meals. In temperate months throw open French doors to let in warm breezes or take the party outside to a magical flagstone patio for drinks and hors d'oeuvres riverside! Admire the extensive hand-placed granite embankment and dock where you’ll have easy access to swimming and boating. At day’s end savor panoramic sunsets from your favorite front yard chair or from the screened in porch that spans the front of the home. The first floor primary is a welcome sanctuary boasting easy access to the hot tub for soothing soaks while guests delight in two second level bedrooms. A finished living space above the garage is versatile for long-term guests or creative projects. RELAXATION AND BEAUTY BY DESIGN! A TRULY SPECIAL PLACE TO CALL HOME!